Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnLineItem(TR_LTM_SLS_RTN) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnLineItem(TR_LTM_SLS_RTN) |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | SerializedUnit(AS_UN_SRZ) |
SerialNumber (FK) | A unique code, which can be either alpha, numeric or alpha-numeric, to identify an individual instance of an ITEM. | ID_NMB_SRZ | Name | varchar(40) | SerializedUnit(AS_UN_SRZ) |
TypeCode | A code denoting if this is a sale, rental or sale of a related item (eg: Service Contract) | TY_SRZ | Code2 | char(2) | |